﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 会员管理实体类：fanli_users 。
	/// </summary>
	[Serializable]
	public class fanli_users
	{
		public fanli_users()
		{}

		#region Model
		private int _id; //id
		private string _username; //用户名
		private string _password; //密码
		private string _email; //邮箱
		private DateTime? _regdate; //注册时间
		private int _lognum; //登录次数
		private string _regip; //注册ip
		private DateTime? _lastlogtime; //最后一次登录时间
		private string _lastlogip; //最后一次登录ip
		private string _realname; //真实姓名
		private string _telephone; //电话
		private string _mobailePhone; //手机
		private string _qq; //qq
		private string _passquestion; //密码问题
		private string _passanswer; //密码答案
		private int _status; //用户状态
		private int _askjoinID; //上线id
		private int _level; //等级
		private int _score; //积分
		private float _money; //余额
		private int _isVip; //是否vip
		private string _ext1; //扩展1
		private string _ext2; //扩展2
		private string _ext3; //扩展3
		private string _ext4; //扩展4


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 用户名
		/// </summary>
		public string username
		{
			set{ _username=value;}
			get{return _username;}
		}
        /// <summary>
		/// 密码
		/// </summary>
		public string password
		{
			set{ _password=value;}
			get{return _password;}
		}
        /// <summary>
		/// 邮箱
		/// </summary>
		public string email
		{
			set{ _email=value;}
			get{return _email;}
		}
        /// <summary>
		/// 注册时间
		/// </summary>
		public DateTime? regdate
		{
			set{ _regdate=value;}
			get{return _regdate;}
		}
        /// <summary>
		/// 登录次数
		/// </summary>
		public int lognum
		{
			set{ _lognum=value;}
			get{return _lognum;}
		}
        /// <summary>
		/// 注册ip
		/// </summary>
		public string regip
		{
			set{ _regip=value;}
			get{return _regip;}
		}
        /// <summary>
		/// 最后一次登录时间
		/// </summary>
		public DateTime? lastlogtime
		{
			set{ _lastlogtime=value;}
			get{return _lastlogtime;}
		}
        /// <summary>
		/// 最后一次登录ip
		/// </summary>
		public string lastlogip
		{
			set{ _lastlogip=value;}
			get{return _lastlogip;}
		}
        /// <summary>
		/// 真实姓名
		/// </summary>
		public string realname
		{
			set{ _realname=value;}
			get{return _realname;}
		}
        /// <summary>
		/// 电话
		/// </summary>
		public string telephone
		{
			set{ _telephone=value;}
			get{return _telephone;}
		}
        /// <summary>
		/// 手机
		/// </summary>
		public string mobailePhone
		{
			set{ _mobailePhone=value;}
			get{return _mobailePhone;}
		}
        /// <summary>
		/// qq
		/// </summary>
		public string qq
		{
			set{ _qq=value;}
			get{return _qq;}
		}
        /// <summary>
		/// 密码问题
		/// </summary>
		public string passquestion
		{
			set{ _passquestion=value;}
			get{return _passquestion;}
		}
        /// <summary>
		/// 密码答案
		/// </summary>
		public string passanswer
		{
			set{ _passanswer=value;}
			get{return _passanswer;}
		}
        /// <summary>
		/// 用户状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 上线id
		/// </summary>
		public int askjoinID
		{
			set{ _askjoinID=value;}
			get{return _askjoinID;}
		}
        /// <summary>
		/// 等级
		/// </summary>
		public int level
		{
			set{ _level=value;}
			get{return _level;}
		}
        /// <summary>
		/// 积分
		/// </summary>
		public int score
		{
			set{ _score=value;}
			get{return _score;}
		}
        /// <summary>
		/// 余额
		/// </summary>
		public float money
		{
			set{ _money=value;}
			get{return _money;}
		}
        /// <summary>
		/// 是否vip
		/// </summary>
		public int isVip
		{
			set{ _isVip=value;}
			get{return _isVip;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
        /// <summary>
		/// 扩展3
		/// </summary>
		public string ext3
		{
			set{ _ext3=value;}
			get{return _ext3;}
		}
        /// <summary>
		/// 扩展4
		/// </summary>
		public string ext4
		{
			set{ _ext4=value;}
			get{return _ext4;}
		}
		#endregion Model

		#region txt document
		/*
会员管理,users
id,用户名,密码,邮箱,注册时间,登录次数,注册ip,最后一次登录时间,最后一次登录ip,真实姓名,电话,手机,qq,密码问题,密码答案,用户状态,上线id,等级,积分,余额,是否vip,扩展1,扩展2,扩展3,扩展4
id,username,password,email,regdate,lognum,regip,lastlogtime,lastlogip,realname,telephone,mobailePhone,qq,passquestion,passanswer,status,askjoinID,level,score,money,isVip,ext1,ext2,ext3,ext4
i,c100,c64,c120,d,i,c20,d,c20,c100,c20,c20,c20,c100,c100,i,i,i,i,f,i,c100,c100,c100,c100


--------------------------
-- 创建表[会员管理]开始: 
-- alter table  [fanli_users] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_users') drop table fanli_users
  CREATE TABLE [fanli_users] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [username] [varchar] (100),
	 [password] [varchar] (64),
	 [email] [varchar] (120),
	 [regdate] [datetime],
	 [lognum] int,
	 [regip] [varchar] (20),
	 [lastlogtime] [datetime],
	 [lastlogip] [varchar] (20),
	 [realname] [varchar] (100),
	 [telephone] [varchar] (20),
	 [mobailePhone] [varchar] (20),
	 [qq] [varchar] (20),
	 [passquestion] [varchar] (100),
	 [passanswer] [varchar] (100),
	 [status] int,
	 [askjoinID] int,
	 [level] int,
	 [score] int,
	 [money] [float],
	 [isVip] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100),
	 [ext3] [varchar] (100),
	 [ext4] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'会员管理 ',N'user',N'dbo',N'table',N'fanli_users', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_users',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'用户名',N'user',N'dbo',N'table',N'fanli_users',N'column',N'username'
 exec sp_addextendedproperty N'MS_Description',N'密码',N'user',N'dbo',N'table',N'fanli_users',N'column',N'password'
 exec sp_addextendedproperty N'MS_Description',N'邮箱',N'user',N'dbo',N'table',N'fanli_users',N'column',N'email'
 exec sp_addextendedproperty N'MS_Description',N'注册时间',N'user',N'dbo',N'table',N'fanli_users',N'column',N'regdate'
 exec sp_addextendedproperty N'MS_Description',N'登录次数',N'user',N'dbo',N'table',N'fanli_users',N'column',N'lognum'
 exec sp_addextendedproperty N'MS_Description',N'注册ip',N'user',N'dbo',N'table',N'fanli_users',N'column',N'regip'
 exec sp_addextendedproperty N'MS_Description',N'最后一次登录时间',N'user',N'dbo',N'table',N'fanli_users',N'column',N'lastlogtime'
 exec sp_addextendedproperty N'MS_Description',N'最后一次登录ip',N'user',N'dbo',N'table',N'fanli_users',N'column',N'lastlogip'
 exec sp_addextendedproperty N'MS_Description',N'真实姓名',N'user',N'dbo',N'table',N'fanli_users',N'column',N'realname'
 exec sp_addextendedproperty N'MS_Description',N'电话',N'user',N'dbo',N'table',N'fanli_users',N'column',N'telephone'
 exec sp_addextendedproperty N'MS_Description',N'手机',N'user',N'dbo',N'table',N'fanli_users',N'column',N'mobailePhone'
 exec sp_addextendedproperty N'MS_Description',N'qq',N'user',N'dbo',N'table',N'fanli_users',N'column',N'qq'
 exec sp_addextendedproperty N'MS_Description',N'密码问题',N'user',N'dbo',N'table',N'fanli_users',N'column',N'passquestion'
 exec sp_addextendedproperty N'MS_Description',N'密码答案',N'user',N'dbo',N'table',N'fanli_users',N'column',N'passanswer'
 exec sp_addextendedproperty N'MS_Description',N'用户状态',N'user',N'dbo',N'table',N'fanli_users',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'上线id',N'user',N'dbo',N'table',N'fanli_users',N'column',N'askjoinID'
 exec sp_addextendedproperty N'MS_Description',N'等级',N'user',N'dbo',N'table',N'fanli_users',N'column',N'level'
 exec sp_addextendedproperty N'MS_Description',N'积分',N'user',N'dbo',N'table',N'fanli_users',N'column',N'score'
 exec sp_addextendedproperty N'MS_Description',N'余额',N'user',N'dbo',N'table',N'fanli_users',N'column',N'money'
 exec sp_addextendedproperty N'MS_Description',N'是否vip',N'user',N'dbo',N'table',N'fanli_users',N'column',N'isVip'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'fanli_users',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'fanli_users',N'column',N'ext2'
 exec sp_addextendedproperty N'MS_Description',N'扩展3',N'user',N'dbo',N'table',N'fanli_users',N'column',N'ext3'
 exec sp_addextendedproperty N'MS_Description',N'扩展4',N'user',N'dbo',N'table',N'fanli_users',N'column',N'ext4'

-- 创建表[会员管理]结束。 
--------------------------

		*/
		#endregion document
	}
}

